def List_Search(List, Key): return [s for s in List if Key in s]
def List_Diff(Inp_A, Inp_B):
# Inp_A: A list
# Inp_B: A list
Out=list(set(Inp_A)-set(Inp_B))
return Out
# Creating a new list of Columns
Columns = List_Diff(Data.columns.tolist(), List_Search(Data.columns.tolist(), 'Moving Ave'))
Columns = List_Diff(Columns, ['Symbol'])
Temp = ['Ave. ' + i for i in Columns]
# A new DataFrame
Ave_df = pd.DataFrame({'Symbol':Symbols_list})
for i in Temp:
Ave_df[i]=''
del Temp
# Progress Bar
Counter = 0
Progress_Bar = progressbar.ProgressBar(maxval=len(Symbols_list),
widgets=[progressbar.Bar('#', '|', '|'), progressbar.Percentage()])
Progress_Bar.start()
for i in range(len(Symbols_list)):
Counter+=1
Progress_Bar.update(Counter)
Ave_df.iloc[i,1:] = Data[Data.Symbol == Symbols_list[i]][Columns].mean().values
Progress_Bar.finish()
display(Ave_df.style.hide_index().set_precision(2).bar(subset=['Ave. Volume'], align='mid', color=['Lime'])\
.bar(subset=['Ave. Adj Close'], align='mid', color=['Salmon'])\
.set_properties(subset=['Symbol'], **{'background-color': 'DimGray', 'color': 'White'}))
Temp = pd.melt(Ave_df, id_vars=['Symbol'], value_vars=list(set(Ave_df.columns)-{'Symbol'}),
var_name='Summary', value_name='Value')
fig = make_subplots(rows=2, cols=1, vertical_spacing = 0.1, shared_yaxes=True,
subplot_titles=('Ave. Volume', 'Summary'))
# Top
fig1 = px.bar(Ave_df.round(0), x= 'Symbol', y= 'Ave. Volume', orientation='v', text = 'Ave. Volume',
hover_data= Ave_df.columns)
for i in range(len(fig1['data'])):
fig.add_trace(fig1['data'][i], row=1, col=1)
fig.update_traces(marker_line_color= 'Black', marker_line_width=1, opacity=1, row=1, col=1)
# Bottom
fig2 = px.bar(Temp.loc[Temp.Summary != 'Ave. Volume'].round(0), x= 'Symbol', y = 'Value',
color = 'Summary', orientation='v', hover_data= Temp.columns)
for i in range(len(fig2['data'])):
fig.add_trace(fig2['data'][i], row=2, col=1)
fig.update_traces(marker_line_color= 'Black', marker_line_width=1, opacity=1, showlegend = True, row=2, col=1)
# Update
fig.update_xaxes(showline=True, linewidth=1, linecolor='Lightgray', mirror=True,
zeroline=False, zerolinewidth=1, zerolinecolor='Black',
showgrid=True, gridwidth=1, gridcolor='Lightgray')
fig.update_yaxes(showline=True, linewidth=1, linecolor='Lightgray', mirror=True,
zeroline=False, zerolinewidth=1, zerolinecolor='Black', title_text='Value',
showgrid=False, gridwidth=1, gridcolor='Lightgray')
fig.update_layout(legend_orientation='v', plot_bgcolor= 'white', height= 800)
fig.update_layout(legend=dict(font=dict(color="Black"), bordercolor="Lightgray", borderwidth=1))
fig.update_layout(title={'text': '<b>' + 'Average Values' + '<b>', 'x':0.5, 'y': .95, 'xanchor': 'center', 'yanchor': 'top'})
fig.show()
